Enhancements to AR Unapplied Payments Report (Dynamic)

The AR Unapplied Payments report (Dynamic) in Stay has been enhanced to display the aging details of unapplied payments made to A/R accounts. Previously, the aging details for the unapplied payments were not displayed.

To support this enhancement, the following changes have been made:

A new single-select drop-down list, View By, has been added that displays the following options:
- Date
- Date Range

Field	Description
Date	When selected, a new field, Payment Date (From) is displayed. This is a mandatory field that allows users to select a date from which the unapplied payments made, and their aging details must be displayed. Users can select a date that is a maximum of 1 year prior to or beyond the current property date.
Date Range	When selected, the following fields are displayed: Payment Date (From) Payment Date (To) These are mandatory fields that allow users to select the date range within which the unapplied payments are made, and their aging details must be displayed. Users can select a date that is a maximum of 5 years prior to or beyond the current property date. The maximum date range that can be selected is 365 days.

Field

Description

Date

When selected, a new field, Payment Date (From) is displayed. This is a mandatory field that allows users to select a date from which the unapplied payments made, and their aging details must be displayed. Users can select a date that is a maximum of 1 year prior to or beyond the current property date.

Date Range

When selected, the following fields are displayed:

Payment Date (From)
Payment Date (To)

These are mandatory fields that allow users to select the date range within which the unapplied payments are made, and their aging details must be displayed. Users can select a date that is a maximum of 5 years prior to or beyond the current property date. The maximum date range that can be selected is 365 days.

The following new columns have been added:
- Available Amount
- Current
- 31-60 days
- 61-90 days
- 91-120 days
- 121+ days
- Status
- Unapplied Payment (User)
The following table lists the details displayed in the new columns:

Field	Description
Available Amount	This column is displayed next to the Payment Amount column. The balance of unapplied payments are displayed in this column and calculated as follows: Available Amount = Payment Amount- Payment Applied. For example, when an A/R account has an unapplied amount of $300 and when it is applied to make payment for an invoice of $120, then the available amount is displayed as $180. This column can be sorted.
Current 31-60 days 61-90 days 91-120 days 121+ days	The available amount is displayed in each of the aging columns based on the following calculation: Current Property Date - Payment Date. For example, consider the following details for an A/R account: Payment date - 26^th June 2025 Current property date - 16^th September 2025 Payment amount - $300 Payment applied - $120 Available Amount = $300 - $120 = $180. As the aging period for the available amount is 82 days, the available amount is displayed in the 61 - 90 days column.
Status	The following values are displayed in this column: Partially Applied: Displayed when the unapplied payment is applied to a partial amount of an invoice. Unapplied: Displayed when the unapplied payment is not applied to any invoice. The unapplied payments with the status Closed are not displayed in the report.
Unapplied Payment (User)	The user who made the unapplied payment.

The Payment Applied column is enhanced to display the amount based on the following criteria:

Scenario	Description
User has made unapplied payment	When the user has made unapplied payments without applying to any invoice, the payment applied will be displayed as $0.
User has made unapplied payment and applied to invoice(s)	When the user has made unapplied payments and applied the payments to single or multiple invoices, the sum of the payments applied to all the invoices will be displayed.
User has made an overpayment that results in unapplied payments	When users make an overpayment to an invoice, the excess amount from the amount will be posted as Available Amount and classified under the respective aging column. For example, consider the following details for an A/R account: Payment date - 3^rd August 2025 Current property date - 16^th September 2025 When a user makes an overpayment of $500 for an invoice of $100, the excess amount of $400 is posted as an unapplied payment. As the aging for the available amount is 44 days, the available amount of $400 will be displayed in 31-60 days column.
User requests a refund for the unapplied payment made to an invoice	When a user has made a payment to an invoice using unapplied payments and requests for a refund, the following entries are displayed: The payment amount in the Payment Applied column. Record for the amount refunded highlighted in red colour.